Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP10100
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Sales Transaction Work Group Display Name: Sales Work
Physical Name: SOP10100
Technical Name: SOP_HDR_WORK
Group Technical Name: Sales Work
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | SOPTYPE  | SOP Type | Integer | DDL_SOP_Type | 0 | |
| 2 | SOPNUMBE | SOP Number | String | STR20_SOP_Number | 17 | |
| 3 | ORIGTYPE | Original Type | Integer | DDL_SOP_Type | 0 | |
| 4 | ORIGNUMB | Original Number | String | STR20_SOP_Number | 17 | |
| 5 | DOCID | Document ID | String | STR15_LBAU | 15 | |
| 6 | DOCDATE | Document Date | Date | DT | 8 | |
| 7 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 8 | QUOTEDAT | Quote Date | Date | DT | 8 | |
| 9 | QUOEXPDA | Quote Expiration Date | Date | DT | 8 | |
| 10 | ORDRDATE | Order Date | Date | DT | 8 | |
| 11 | INVODATE | Invoice Date | Date | DT | 8 | |
| 12 | BACKDATE | Back Order Date | Date | DT | 8 | |
| 13 | RETUDATE | Return Date | Date | DT | 8 | |
| 14 | ReqShipDate | Requested Ship Date | Date | DT | 8 | |
| 15 | FUFILDAT | Fulfillment Date | Date | DT | 8 | |
| 16 | ACTLSHIP | Actual Ship Date | Date | DT | 8 | |
| 17 | DISCDATE | Discount Date | Date | DT | 8 | |
| 18 | DUEDATE | Due Date | Date | DT | 8 | |
| 19 | REPTING | Repeating | Boolean | CB_Repeating | 0 | |
| 20 | TRXFREQU | TRX Frequency | Integer | DDL_TRX_Frequency | 0 | |
| 21 | TIMEREPD | Times Repeated | Integer | INT4_U0 | 4 | |
| 22 | TIMETREP | Times To Repeat | Integer | INT4_U0 | 4 | |
| 23 | DYSTINCR | Days to Increment | Integer | INT3_RB0_U | 3 | |
| 24 | DTLSTREP | Date Last Repeated | Date | DT | 8 | |
| 25 | DSTBTCH1 | Dest Batch 1 | String | STR15_LBAU | 15 | |
| 26 | DSTBTCH2 | Dest Batch 2 | String | STR15_LBAU | 15 | |
| 27 | USDOCID1 | Use Document ID 1 | String | STR15_LBAU | 15 | |
| 28 | USDOCID2 | Use Document ID 2 | String | STR15_LBAU | 15 | |
| 29 | DISCFRGT | Discount Available Freight | Currency | DLR17_RBS0_UTR$ | 17 | |
| 30 | ORDAVFRT | Originating Discount Available Freight | Currency | DLR17_RBS0_UTR$ | 17 | |
| 31 | DISCMISC | Discount Available Misc | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | ORDAVMSC | Originating Discount Available Misc | Currency | DLR17_RBS0_UTR$ | 17 | |
| 33 | DISAVAMT | Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 34 | ORDAVAMT | Originating Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 35 | DISCRTND | Discount Returned | Currency | DLR17_RBS0_STR$ | 17 | |
| 36 | ORDISRTD | Originating Discount Returned | Currency | DLR17_RBS0_STR$ | 17 | |
| 37 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 38 | ORDISTKN | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 39 | DSCPCTAM | Discount Percent Amount | Integer | INT5_%2 | 5 | |
| 40 | DSCDLRAM | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 41 | ORDDLRAT | Originating Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 42 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 43 | ORDATKN | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 44 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['Sales Transaction Work'].PYMTRMID AS 'Sales Transaction Work-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['Sales Transaction Work'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
| 45 | PRCLEVEL | PriceLevel | String | STR10_LBAU | 10 | |
| 46 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Sales Transaction Work'].LOCNCODE AS 'Sales Transaction Work-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Sales Transaction Work'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 47 | BCHSOURC | Batch Source | String | STR15 | 15 | |
| 48 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 49 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['Sales Transaction Work'].CUSTNMBR AS 'Sales Transaction Work-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Sales Transaction Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 50 | CUSTNAME | Customer Name | String | STR64_Customer_Name | 64 | |
| 51 | CSTPONBR | Customer PO Number | String | STR20_Document_Number | 20 | |
| 52 | PROSPECT | Prospect | Integer | INT1 | 1 | |
| 53 | MSTRNUMB | Master Number | Long Integer | LI_MasterNumber | 9 | |
| 54 | PCKSLPNO | Packing Slip Number | String | STR20_IVC_Document_Number | 17 | |
| 55 | PICTICNU | Picking Ticket Number | String | STR20_SOP_Number | 17 | |
| 56 | MRKDNAMT | Markdown Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 57 | ORMRKDAM | Originating Markdown Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 58 | PRBTADCD | Primary Billto Address Code | String | STR15_LBAU | 15 | |
| 59 | PRSTADCD | Primary Shipto Address Code | String | STR15_LBAU | 15 | |
| 60 | CNTCPRSN | Contact Person | String | STR60 | 60 | |
| 61 | ShipToName | ShipToName | String | STR64_Customer_Name | 64 | |
| 62 | ADDRESS1 | Address 1 | String | STR60 | 60 | |
| 63 | ADDRESS2 | Address 2 | String | STR60 | 60 | |
| 64 | ADDRESS3 | Address 3 | String | STR60 | 60 | |
| 65 | CITY | City | String | STR35 | 35 | |
| 66 | STATE | State | String | STR30_State | 29 | |
| 67 | ZIPCODE | Zip Code | String | STR10 | 10 | |
| 68 | CCode | Country Code | String | STR6_VAT | 6 | |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['Sales Transaction Work'].CCode AS 'Sales Transaction Work-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Sales Transaction Work'].CCode = ['VAT Country Code MSTR'].CCode | ||||||
| 69 | COUNTRY | Country | String | STR60 | 60 | |
| 70 | PHNUMBR1 | Phone Number 1 | String | Phone_Number | 14 | |
| 71 | PHNUMBR2 | Phone Number 2 | String | Phone_Number | 14 | |
| 72 | PHONE3 | Phone 3 | String | Phone_Number3 | 14 | |
| 73 | FAXNUMBR | Fax Number | String | STR14_FAX | 14 | |
| 74 | COMAPPTO | Commission Applied To | Integer | GB | 0 | |
| 75 | COMMAMNT | Commission Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 76 | OCOMMAMT | Originating Commission Amount | Currency | DLR17_RBSO_STR$ | 17 | |
| 77 | CMMSLAMT | Commission Sale Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 78 | ORCOSAMT | Originating Commission Sales Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 79 | NCOMAMNT | Non-Commissioned Amount | Currency | DLR19_RBS0_STR$ | 19 | |
| 80 | ORNCMAMT | Originating Non-Commissioned Amount | Currency | DLR19_RBS0_STR$ | 19 | |
| 81 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['Sales Transaction Work'].SHIPMTHD AS 'Sales Transaction Work-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Sales Transaction Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 82 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 83 | ORTDISAM | Originating Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 84 | TRDISPCT | Trade Discount Percent | Integer | INT4_%2 | 4 | |
| 85 | SUBTOTAL | Subtotal | Currency | DLR17_RBS0_STR$ | 17 | |
| 86 | ORSUBTOT | Originating Subtotal | Currency | DLR17_RBS0_STR$ | 17 | |
| 87 | REMSUBTO | Remaining Subtotal | Currency | DLR17_RBS0_UTR$ | 17 | |
| 88 | OREMSUBT | Originating Remaining Subtotal | Currency | DLR17_RBS0_UTR$ | 17 | |
| 89 | EXTDCOST | Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 90 | OREXTCST | Originating Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 91 | FRTAMNT | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 92 | ORFRTAMT | Originating Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 93 | MISCAMNT | Misc Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 94 | ORMISCAMT | Originating Misc Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 95 | TXENGCLD | Tax Engine Called | Boolean | YN | 0 | |
| 96 | TAXEXMT1 | Tax Exempt 1 | String | STR25 | 25 | |
| 97 | TAXEXMT2 | Tax Exempt 2 | String | STR25 | 25 | |
| 98 | TXRGNNUM | Tax Registration Number | String | STR25 | 25 | |
| 99 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['Sales Transaction Work'].TAXSCHID AS 'Sales Transaction Work-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Sales Transaction Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 100 | TXSCHSRC | Tax Schedule Source | Integer | INT1 | 1 | |
| 101 | BSIVCTTL | Based On Invoice Total | Boolean | YN | 0 | |
| 102 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['Sales Transaction Work'].FRTSCHID AS 'Sales Transaction Work-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Sales Transaction Work'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 103 | FRTTXAMT | Freight Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 104 | ORFRTTAX | Originating Freight Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 105 | FRGTTXBL | Freight Taxable | Integer | DDL_Tax_Options | 0 | |
| 106 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['Sales Transaction Work'].MSCSCHID AS 'Sales Transaction Work-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Sales Transaction Work'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 107 | MSCTXAMT | Misc Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 108 | ORMSCTAX | Originating Misc Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 109 | MISCTXBL | Misc Taxable | Integer | DDL_Tax_Options | 0 | |
| 110 | BKTFRTAM | Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 111 | ORBKTFRT | Originating Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 112 | BKTMSCAM | Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 113 | ORBKTMSC | Originating Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 114 | BCKTXAMT | Backout Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 115 | OBTAXAMT | Originating Backout Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 116 | TXBTXAMT | Taxable Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 117 | OTAXTAMT | Originating Taxable Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 118 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 119 | ORTAXAMT | Originating Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 120 | ECTRX | EC Transaction | Boolean | CB_EC_Transaction | 0 | |
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction. | ||||||
| 121 | DOCAMNT | Document Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 122 | ORDOCAMT | Originating Document Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 123 | PYMTRCVD | Payment Received | Currency | DLR19_RBS0_UTR$ | 19 | |
| 124 | ORPMTRVD | Originating Payment Received | Currency | DLR19_RBS0_UTR$ | 19 | |
| 125 | DEPRECVD | Deposit Received | Currency | DLR19_RBS0_UTR$ | 19 | |
| 126 | ORDEPRVD | Originating Deposit Received | Currency | DLR19_RBS0_UTR$ | 19 | |
| 127 | CODAMNT | COD Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 128 | ORCODAMT | Originating COD Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 129 | ACCTAMNT | Account Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 130 | ORACTAMT | Originating Account Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 131 | SALSTERR | Sales Territory | String | STR15_Sales_Territory | 15 | |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['Sales Transaction Work'].SALSTERR AS 'Sales Transaction Work-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['Sales Transaction Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR | ||||||
| 132 | SLPRSNID | Salesperson ID | String | STR15_Salesperson_ID | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['Sales Transaction Work'].SLPRSNID AS 'Sales Transaction Work-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['Sales Transaction Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
| 133 | UPSZONE | UPS Zone | String | STR3 | 3 | |
| 134 | TIMESPRT | Times Printed | Integer | INT4_U0 | 4 | |
| 135 | PSTGSTUS | Posting Status | Integer | INT | 0 | |
| 136 | VOIDSTTS | Void Status | Integer | INT | 0 | |
| 137 | ALLOCABY | Allocate By | Integer | DDL_Allocate_By | 0 | |
| 138 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Sales Transaction Work'].NOTEINDX AS 'Sales Transaction Work-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Sales Transaction Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 139 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Sales Transaction Work'].CURNCYID AS 'Sales Transaction Work-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Sales Transaction Work'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 140 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Sales Transaction Work'].CURRNIDX AS 'Sales Transaction Work-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Sales Transaction Work'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
| 141 | RATETPID | Rate Type ID | String | STR15_Rate_Type_ID | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['Sales Transaction Work'].RATETPID AS 'Sales Transaction Work-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Sales Transaction Work'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
| 142 | EXGTBLID | Exchange Table ID | String | STR15_Exchange_Table_ID | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['Sales Transaction Work'].EXGTBLID AS 'Sales Transaction Work-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Sales Transaction Work'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
| 143 | XCHGRATE | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 144 | DENXRATE | Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 145 | EXCHDATE | Exchange Date | Date | DT_Date | 6 | |
| 146 | TIME1 | Time | Time | TM6 | 6 | |
| 147 | RTCLCMTD | Rate Calculation Method | Integer | GB | 0 | |
| 148 | MCTRXSTT | MC Transaction State | Integer | INT1 | 1 | |
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.
Click to show/hide MC Transaction States0 Euro currency is not created or no denomination currencies are enabled.
1 Originating is not a denomination; Functional is not a denomination
2 Originating is not a denomination; Functional is the Euro currency.
3 Originating is not a denomination; Functional is a denomination.
4 Originating is a denomination; Functional is not a denomination.
5 Originating is a denomination; Functional is a denomination.
6 Originating is a denomination; Functional is the Euro currency.
7 Originating is the Euro currency; Functional is a denomination.
8 Originating is the Euro currency; Functional is not a denomination.
| ||||||
| 149 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 150 | SOPHDRE1 | SOP HDR Errors 1 | Long Integer | ML_SOP_HDR_Errors_1 | 0 | |
| 151 | SOPHDRE2 | SOP HDR Errors 2 | Long Integer | ML_SOP_HDR_Errors_2 | 0 | |
| 152 | SOPLNERR | SOP LINE Errors | Long Integer | ML_SOP_LINE_Errors | 0 | |
| 153 | SOPHDRFL | SOP HDR Flags | Long Integer | ML_SOP_HDR_Flags | 0 | |
| 154 | SOPMCERR | SOP MC Posting Error Messages | Long Integer | SOP MC Posting Error Messages | 0 | |
| 155 | COMMNTID | Comment ID | String | STR15_Comment_ID | 15 | |
Key to the Comment Master (SY04200).
Click to show/hideSELECT
['Sales Transaction Work'].COMMNTID AS 'Sales Transaction Work-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Sales Transaction Work'].COMMNTID = ['Comment Master'].COMMNTID | ||||||
| 156 | REFRENCE | Reference | String | STR30 | 30 | |
| 157 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 158 | PTDUSRID | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Sales Transaction Work'].PTDUSRID AS 'Sales Transaction Work-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Sales Transaction Work'].PTDUSRID = ['Users Master'].USERID | ||||||
| 159 | USER2ENT | User To Enter | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Sales Transaction Work'].USER2ENT AS 'Sales Transaction Work-User To Enter'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SOP10100 AS ['Sales Transaction Work']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Sales Transaction Work'].USER2ENT = ['Users Master'].USERID | ||||||
| 160 | CREATDDT | Created Date | Date | DT | 8 | |
| 161 | MODIFDT | Modified Date | Date | DT | 8 | |
| 162 | Tax_Date | Tax Date | Date | DT | 8 | |
| 163 | APLYWITH | Apply Withholding | Boolean | Boolean | 0 | |
| 164 | WITHHAMT | Withholding Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 165 | SHPPGDOC | Shipping Document | Boolean | CB_Shipping_Document | 0 | |
| 166 | CORRCTN | Correction | Boolean | CB_Correction | 0 | |
| 167 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
| 168 | CORRNXST | Correction to Nonexisting Transaction | Boolean | Boolean | 0 | |
| 169 | DOCNCORR | Document Number Corrected | String | Document_Number | 20 | |
| 170 | SEQNCORR | Sequence Number Corrected | Integer | INT | 0 | |
| 171 | SALEDATE | Sale Date | Date | DT | 8 | |
| 172 | SOPHDRE3 | SOP HDR Errors 3 | Long Integer | ML_SOP_HDR_Errors_3 | 0 | |
| 173 | EXCEPTIONALDEMAND | Exceptional Demand | Boolean | CB_Exceptional_Demand | 0 | |
| 174 | Flags | Flags | Integer | INT1 | 1 | |
| 175 | BackoutTradeDisc | Backout Trade Discount Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 176 | OrigBackoutTradeDisc | Originating Backout Trade Discount Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 177 | GPSFOINTEGRATIONID | GPSFO Integration ID | String | STR30 | 30 | |
| 178 | INTEGRATIONSOURCE | Integration Source | Integer | INT | 0 | |
| 179 | INTEGRATIONID | Integration ID | String | STR30 | 30 | |
| 180 | SOPSTATUS | SOP Status | Integer | INT | 0 | |
| 181 | SHIPCOMPLETE | Ship Complete Document | Boolean | CB_ShipComplete | 0 | |
| 182 | DIRECTDEBIT | Direct Debit | Boolean | CB_DirectDebit | 0 | |
| 183 | WorkflowApprStatCreditLm | Workflow Approval Status Credit Limit | Integer | DDL_WorkflowApprovalStatus | 0 | |
| 184 | WorkflowPriorityCreditLm | Workflow Priority Credit Limit | Integer | DDL_WorkflowPriority | 0 | |
| 185 | WorkflowApprStatusQuote | Workflow Approval Status Quote | Integer | DDL_WorkflowApprovalStatus | 0 | |
| 186 | WorkflowPriorityQuote | Workflow Priority Quote | Integer | DDL_WorkflowPriority | 0 | |
| 187 | Workflow_Status | Workflow Status | Integer | Workflow Status | 0 | |
| 188 | ContractExchangeRateStat | Contract Exchange Rate Status | Integer | INT | 0 | |
| 189 | Print_Phone_NumberGB | Print Phone Number GB | Integer | GB | 0 | |